How to: Type criteria in a query to retrieve data.
Solution:
Type criteria in the 'Criteria' and/or 'or' rows of the query design grid in the Query Design view.
NOTE: For a record to be included in the data returned by the query when it is run, the record must meet the criteria specified in the 'Criteria' and/or 'or' rows in the query design grid.
Design grid
1) If the Database window is not active, activate the Database window.
2) If the query is not open, open the Query Design view.
3) Click in the 'Criteria' row for the desired field in the design grid in the bottom half of the Query Design window.
Criteria row
4) Type the desired criteria.
NOTE 1: Select 'Build...' to have the expression builder help build an expression.
NOTE 2: Type a prompt in brackets for a parameter query.
5) (Optional) To specify additional criteria for the same field:
NOTE: For a record to be returned by the query, one of the criteria specified in the 'Criteria' and 'OR' rows must be met.
a) Click in the 'or' row for the same field in the design grid.
NOTE: 'Or' means that one or the other of the defined criteria must be true.
or row
b) Type the desired criteria.
NOTE 1: Select 'Build...' to have the expression builder help build an expression.
NOTE 2: Type a prompt in brackets for a parameter query.
c) Repeat steps 5)a) and 5)b) in each 'or' row until the desired number of criteria have been typed for that field.
6) Repeat steps 3) through 5) for each field in the query design grid for which to enter criteria.
7) Select the 'File' menu and select 'Save' to save the query.
8) Select the 'File' menu and select 'Close' to close the Query Design view.
